1 -- phpMyAdmin SQL Dump
2 -- version 4.6.5.2
3 -- https://www.phpmyadmin.net/
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Sep 28, 2018 at 10:10 AM
7 -- Server version: 10.1.21-MariaDB
8 -- PHP Version: 5.6.30
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8mb4 */;
18
19 --
20 -- Database: `f1`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `customer`
27 --
28
29 CREATE TABLE `customer` (
30 `userId` varchar(12) NOT NULL,
31 `customerName` varchar(30) NOT NULL,
32 `phoneNumber` varchar(14) NOT NULL,
33 `address` varchar(50) NOT NULL
34 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
35
36 --
37 -- Dumping data for table `customer`
38 --
39
40 INSERT INTO `customer` (`userId`, `customerName`, `phoneNumber`, `address`) VALUES
41 ('c001', 'Customer', '+8801234567890', 'banani'),
42 ('deba', 'Debashish', '+8801763923789', 'Kuril');
43
44 -- --------------------------------------------------------
45
46 --
47 -- Table structure for table `employee`
48 --
49
50 CREATE TABLE `employee` (
51 `userId` varchar(12) NOT NULL,
52 `employeeName` varchar(50) NOT NULL,
53 `phoneNumber` varchar(14) NOT NULL,
54 `role` varchar(8) NOT NULL,
55 `salary` double(8,2) NOT NULL
56 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
57
58 --
59 -- Dumping data for table `employee`
60 --
61
62 INSERT INTO `employee` (`userId`, `employeeName`, `phoneNumber`, `role`, `salary`) VALUES
63 ('e001', 'Employee1', '+8801234567890', 'Manager', 50000.00),
64 ('e002', 'Employee2', '+8801234567891', 'General', 30000.00);
65
66 -- --------------------------------------------------------
67
68 --
69 -- Table structure for table `login`
70 --
71
72 CREATE TABLE `login` (
73 `userId` varchar(12) NOT NULL,
74 `password` varchar(12) NOT NULL,
75 `status` int(1) NOT NULL
76 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
77
78 --
79 -- Dumping data for table `login`
80 --
81
82 INSERT INTO `login` (`userId`, `password`, `status`) VALUES
83 ('e001', 'e001', 0),
84 ('e002', 'e002', 0),
85 ('c001', 'c001', 1),
86 ('deba', 'aaaa', 1);
87
88 -- --------------------------------------------------------
89
90 --
91 -- Table structure for table `product`
92 --
93
94 CREATE TABLE `product` (
95 `productId` int(5) UNSIGNED ZEROFILL NOT NULL,
96 `productName` varchar(50) NOT NULL,
97 `price` double(8,2) NOT NULL,
98 `quantity` int(8) NOT NULL
99 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100
101 --
102 -- Dumping data for table `product`
103 --
104
105 INSERT INTO `product` (`productId`, `productName`, `price`, `quantity`) VALUES
106 (00001, 'Juice 1L', 66.00, 7),
107 (00002, 'Mi Band', 2000.00, 5),
108 (00003, 'Frutika', 55.00, 21),
109 (00004, 'Samsung S9', 89999.00, 5),
110 (00005, 'Bagpack XL', 2500.00, 6);
111
112 -- --------------------------------------------------------
113
114 --
115 -- Table structure for table `purchaseinfo`
116 --
117
118 CREATE TABLE `purchaseinfo` (
119 `purchaseId` int(5) UNSIGNED ZEROFILL NOT NULL,
120 `userId` varchar(12) NOT NULL,
121 `productId` varchar(12) NOT NULL,
122 `cost` double(12,2) UNSIGNED NOT NULL,
123 `amount` int(8) UNSIGNED NOT NULL,
124 `date` varchar(18) NOT NULL
125 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126
127 --
128 -- Dumping data for table `purchaseinfo`
129 --
130
131 INSERT INTO `purchaseinfo` (`purchaseId`, `userId`, `productId`, `cost`, `amount`, `date`) VALUES
132 (00001, 'deba', '00003', 55.00, 1, '2018-09-26'),
133 (00002, 'c001', '00005', 2500.00, 1, '2018-09-28'),
134 (00006, 'c001', '00003', 110.00, 2, '2018-09-28');
135
136 --
137 -- Indexes for dumped tables
138 --
139
140 --
141 -- Indexes for table `customer`
142 --
143 ALTER TABLE `customer`
144 ADD PRIMARY KEY (`userId`);
145
146 --
147 -- Indexes for table `employee`
148 --
149 ALTER TABLE `employee`
150 ADD PRIMARY KEY (`userId`);
151
152 --
153 -- Indexes for table `login`
154 --
155 ALTER TABLE `login`
156 ADD UNIQUE KEY `userId` (`userId`),
157 ADD UNIQUE KEY `userId_2` (`userId`);
158
159 --
160 -- Indexes for table `product`
161 --
162 ALTER TABLE `product`
163 ADD PRIMARY KEY (`productId`);
164
165 --
166 -- Indexes for table `purchaseinfo`
167 --
168 ALTER TABLE `purchaseinfo`
169 ADD PRIMARY KEY (`purchaseId`),
170 ADD KEY `userId` (`userId`),
171 ADD KEY `userId_2` (`userId`);
172
173 --
174 -- AUTO_INCREMENT for dumped tables
175 --
176
177 --
178 -- AUTO_INCREMENT for table `product`
179 --
180 ALTER TABLE `product`
181 MODIFY `productId` int(5) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
182 --
183 -- AUTO_INCREMENT for table `purchaseinfo`
184 --
185 ALTER TABLE `purchaseinfo`
186 MODIFY `purchaseId` int(5) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
187 --
188 -- Constraints for dumped tables
189 --
190
191 --
192 -- Constraints for table `purchaseinfo`
193 --
194 ALTER TABLE `purchaseinfo`
195 ADD CONSTRAINT `FK_PUR_CUS` FOREIGN KEY (`userId`) REFERENCES `purchaseinfo` (`userId`);
196
197 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
198 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
199 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
